[R] Select columns for heatmap in R

Posted by Philipp on Stack Overflow See other posts from Stack Overflow or by Philipp
Published on 2010-06-02T14:41:30Z Indexed on 2010/06/02 14:43 UTC
Read the original article Hit count: 456

Filed under:

heatmap

Hi stackoverflow-pros,

I need your help again :)

I wrote an R script, that generates a heatmap out of a given tab-seperated txt or xls file. At the moment, I delete all columns I don't want to have in the heatmap by hand in the xls file. Now I want to automatize it, but I don't know how :(

The interesting columns all start the same in all xls files, followed by an individual name:

xls-file 1: L1_tpm_xxxx L2_tpm_xxxx L3_tpm_xxxx

xls-file 2: L1_tpm_xxxx L2_tpm_xxxx L3_tpm_xxxx L4_tpm_xxxx L5_tpm_xxxx

Any ideas how to select those columns?

Thanking you in anticipation, Philipp

Related posts about columns

MySQL use certain columns, based on other columns

as seen on Stack Overflow - Search for 'Stack Overflow'
I have this query: SELECT COUNT(articles.id) AS count FROM articles, xml_documents, streams WHERE articles.xml_document_id = xml_documents.id AND xml_documents.stream_id = streams.id AND articles.published_at BETWEEN '2010-01-01' AND '2010-04-01' AND streams.brand_id = 7 Which just uses the… >>> More
save state of a dataGrid: visible columns, columns width and order

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to save remotely (on a database) the state (visible columns, columns width and order) of a Flex3 DataGrid. For width and visibility I can simply save them by accessing each column attribute.. ugly but possible.. But for the order? Do I have to create the dataGrid dynamically?? Any idea is… >>> More
Minimum permission required to access Site Columns page and edit site columns

as seen on Stack Overflow - Search for 'Stack Overflow'
We've started to adopt SharePoint 2010, and are starting to manually migrate content from SharePoint 2007 sites to new sites we're rebuilding from scratch in SP2010. One of the things we previously had supported was to delegate responsibility for managing some of our site columns to a member of the… >>> More
AWK :Extract columns from file: Rows have variable columns

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a text file in the following format. Each row has variable number of columns. File: gi|269201691|ref|YP_003280960.1| chromosomal replication initiation protein gi|57651109|ref|YP_184912.1| chromosomal replication initiation protein… >>> More
Issue Calculating from Rows and Columns(Summing two columns with the third of a different row)

as seen on Stack Overflow - Search for 'Stack Overflow'
With reference to my previous question Adding columns resulting from GROUP BY clause SELECT AcctId,Date, Sum(CASE WHEN DC = 'C' THEN TrnAmt ELSE 0 END) AS C, Sum(CASE WHEN DC = 'D' THEN TrnAmt ELSE 0 END) AS D FROM Table1 where AcctId = '51' GROUP… >>> More

Developer IT